Heather Duff ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	25

About Me

About Me

Analytics

655

Posts

557

Visits

9.4k

Points

Feb 1, 2021

Join Date

Nov 21, 2024

Last Active

Reactions

• Insightful 37

  37
• Vote Up 50

  50
• Awesome 3

  3

• Activity
• Posts5
• Comments650

• Re: Combined Update request across multiple projects/sheets

  Heather Duff

  12/21/21
  Hi @tariq.shaikh@signspecialists.com , Have you considered using the scheduled "send as attachment" option on the report to remind people daily to make updates? It's not necessarily an upda…
  2 ·

• Re: Automating Harvey Balls from the Status column?

  Heather Duff

  04/08/21
  @Sabrina Petersen, try this: =if(Status@row="Not Started","Blue",if(OR(Status@row="In Progress",Status@row="Complete"),"Green",if(Status@row="At…
  1 ·

• Re: formula to show fiscal year

  Heather Duff

  02/26/21
  Hi Katie, Try this, where [Pub Date] is the publication date column. This assumes that your FY running from July 2020-June 2021 is FY21. =IF(MONTH([Pub Date]@row) > 6, YEAR([Pub Date]@row) + 1, YE…
  2 ·

• Re: Calculating years of service

  Heather Duff

  05/10/21
  Hi @Francesca Radabaugh Try this: =IFERROR(IF(DATE(YEAR(TODAY()), MONTH([Start Date]@row), DAY([Start Date]@row)) < TODAY(), YEAR(TODAY()) - YEAR([Start Date]@row), YEAR(TODAY()) - YEAR([Start Dat…
  2 ·

• Re: Nested IF to populate Cell

  Heather Duff

  11/08/21
  Hi @Meagan80 , It looks like you've got an extra equal sign right before your second IF. Try removing that and see if it fixes it. Best, Heather
  1 ·

Next